Client Billing Realization
The Client Billing Realization report is used to see the WIP profitability and analyze historical billing activity in the firm.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
Reports in Foundation that are Comparable
In Practice Management, the comparable report is Client Billing Realization. In Practice Advantage, the comparable report is Billing Realization using the Client option on the Sort/Subtotal tab.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
Hide Penny |
Yes/No |
Includes or excludes pennies in amounts. |
Hide Details |
Yes/No |
Includes or excludes details of each transaction. If excluded, only the headers and footers for each group with amounts only for the grand total display in the report. To view a summary amount for each group, select to subtotal the group. |
Include Deleted Clients |
Yes/No |
Includes or excludes deleted client information. |
Default Filters | ||
---|---|---|
Field Name | Operator | Value |
Transaction Date | Between | First Day Of Current Fiscal Year, Last Day Of Current Fiscal Year |
Optional Filters | ||
---|---|---|
Available Fields | ||
Accounting Period Date |
Client Sub ID |
Return Group |
Business Code |
Client Type |
Service Code ID |
Category ID |
Cost |
Service Code Name |
Category Name |
Final Billed |
Subcategory ID |
Client Bill Manager |
Financial Reporting Client Group |
Subcategory Name |
Client Billing Group |
Gross Profit |
Tax Type |
Client Business Unit |
Line of Business |
Total Amount |
Client ID |
Manager |
Total Billed |
Client ID.Sub ID |
Net Progress |
Total Hours |
Client Name |
Posted Date |
Transaction Date |
Client Office |
Primary Partner |
Write Up/Down |
Client Primary Service Type |
Production |
|
Client Region |
Real % |
|
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client Primary Service Type |
Project Office |
Category ID |
Client Region |
Project Region |
Category Name |
Client Sub ID |
Project Type |
Client |
Client Type |
Return Group |
Client – Principal |
Financial Reporting Client Group |
Service Code ID |
Client Bill Manager |
Line of Business |
Service Code Name |
Client Billing Group |
Manager |
Sort Name |
Client Business Unit |
Primary Partner |
Staff ID |
Client ID |
Project |
Staff Name |
Client ID.Sub ID |
Project Business Unit |
Subcategory ID |
Client Name |
Project ID |
Subcategory Name |
Client Office |
Project Name |
Tax Type |
Sorting | ||
---|---|---|
Available Fields | ||
Client ID |
Net Progress |
Total Billed |
Client Name |
Payments |
Total Hours |
Cost |
Production |
Write Up/Down |
Final Billed |
Real % |
|
Gross Profit |
Total Amount |
|
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Client ID Sub ID |
The client ID and sub-ID (Client ID.Sub-ID). |
Client Name |
The name of the client. |
Total Hours |
The total number of hours included on posted invoices for the invoice date within the selected date range. |
Total Amount |
The total amount of WIP included on posted invoices for the invoice date within the selected date range. |
Final Billed |
The total WIP amount billed + write up – write down. |
Net Progress |
The total of progress billed/applied. |
Total Billed |
The total final billed amount + progress billed – progress applied. |
Write Up/Down |
The total write up/down amount on billed time amounts. |
Real % |
The final billed amount divided by the total WIP amount. |
Cost |
The total cost for each transaction included on the posted invoice. |
Gross Profit |
The final billed amount minus cost. |
Production |
The total amount of WIP transactions with a transaction date in the selected date range, regardless of billed status. |
Client Billing Realization Sample Report